Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
BusinessUnitID (FK)(PK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_BSN_UN | Identity | integer | Tank(LO_TNK) |
TankID (FK)(PK) | A unique identifier for this Tank | ID_TNK | Identity | integer | Tank(LO_TNK) |
TankTemperatureSensorID (PK) | A unique identifier for the TemperatureSensor in a particular Tank | ID_SNSR_TNK_TEMP | Identity | integer | |
Height | The height of the temperature sensor from the bottom of the Tank | QL_HT | Quantity | DECIMAL(9,3) | |